home *** CD-ROM | disk | FTP | other *** search
/ Shareware Grab Bag / Shareware Grab Bag.iso / 090 / kwmacros.arc / 123.KW next >
Encoding:
Text File  |  1986-03-13  |  4.8 KB  |  132 lines
  1. {{F10}<Calculation>{Menu}{1,61}{IdOff}
  2. {Select}{31,32,33,34,53,54,35}{Menu}
  3. {{31}<Sum>@sum({100}.{101}){Enter}
  4. {{32}<Count>@count({100}.{101}){Enter}
  5. {{33}<Average>@avg({100}.{101}){Enter}
  6. {{34}<Maximum>@max({100}.{101}){Enter}
  7. {{100}<msg1>{Text}{24,1,1,80}Move cursor to
  8.  beginning of range, then press Return\{Text}{Pause}{Restore}
  9. {{101}<msg2>{Text}{24,1,1,80}Move cursor to
  10.  end of range, then press Return\{Text}{Pause}{Restore}
  11. {{53}<Horizontal Lookup>@hlookup({120},{121}.{122},{124}){Enter}
  12. {{54}<Vertical Lookup>@vlookup({120},{121}.{122},{123}){Enter}
  13. {{120}<msg1>{Text}{24,1,1,80}Move cursor to
  14.  cell to be looked up, then press Return\{Text}{Pause}{Restore}
  15. {{121}<msg1>{Text}{24,1,1,80}Move cursor to
  16.  top left corner of lookup table, then press Return\{Text}{Pause}
  17. {Restore}
  18. {{122}<msg1>{Text}{24,1,1,80}Move cursor to
  19.  bottom right corner of lookup table, then press Return\{Text}
  20. {Pause}{Restore}
  21. {{123}<msg1>{Text}{24,1,1,80}Enter column f
  22. rom which answer is to be returned (0 - 9), then press Retu
  23. rn\{Text}{FixPause}{1}{Restore}
  24. {{124}<msg1>{Text}{24,1,1,80}Enter row from
  25.  which answer is to be returned (0 - 9), then press Return\
  26. {Text}{FixPause}{1}{Restore}
  27. {{35}<Function F10>{pass}{f10}
  28.  
  29.  
  30.  
  31.  
  32.  
  33. {{F9}<Swap>{Menu}{1,65}{IdOff}{36,37,38}{Menu}
  34.  
  35. {{36}<Row swap>{102}/rncrow1{Enter}.{104}{Enter}/w
  36. ir{Enter}/mrow1{Enter}{Enter}{103}/rncrow2{Enter}.{104}{Enter}
  37. {Pass}{F5}row1{Enter}{Dn}/crow2{Enter}{Enter}{Pass}{F5}row2
  38. {Enter}/crow1{Enter}{Enter}{Pass}{F5}row1{Enter}/wdr{Enter}
  39. /rndrow1{Enter}/rndrow2{Enter}
  40. {{102}<text1>{Text}{24,1,1,80}Move cursor to 
  41. beginning of first row to be swapped, then press Return\{Text}
  42. {Pause}{Restore}
  43. {{103}<text2>{Text}{24,1,1,80}Move cursor to 
  44. beginning of second row to be swapped, then press Return\{Text}
  45. {Pause}{Restore}
  46. {{104}<text3>{Text}{24,1,1,80}Move cursor to 
  47. end of row, then press Return\{Text}{Pause}{Restore}
  48.  
  49. {{37}<Column Swap>{105}/rnccol1{Enter}.{107}{Enter}/w
  50. ic{Enter}/mcol1{Enter}{Enter}{106}/rnccol2{Enter}.{107}{Enter}
  51. {Pass}{F5}col1{Enter}{Rght}/ccol2{Enter}{Enter}{Pass}{F5}co
  52. l2{Enter}/ccol1{Enter}{Enter}{Pass}{F5}col1{Enter}/wdc{Enter}
  53. /rndcol1{Enter}/rndcol2{Enter}
  54. {{105}<text1>{Text}{24,1,1,80}Move cursor to 
  55. top of first column to be swapped, then press Return\{Text}
  56. {Pause}{Restore}
  57. {{106}<text2>{Text}{24,1,1,80}Move cursor to 
  58. top of second column to be swapped, then press Return\{Text}
  59. {Pause}{Restore}
  60. {{107}<text3>{Text}{24,1,1,80}Move cursor to 
  61. end of column, then press Return\{Text}{Pause}{Restore}
  62. {{38}<Function F9>{pass}{f9}
  63.  
  64. {{F7}<Titles>{Menu}{1,65}{IdOff}{Select}{39,40,41,42,43}{Menu}
  65. {{39}<Horizontal>/wth
  66. {{40}<Vertical>/wtv
  67. {{41}<Both>/wtb
  68. {{42}<Clear>/wtc
  69. {{43}<Function F7>{pass}{f7}
  70.  
  71. {{F8}<Windows>{Menu}{1,65}{IdOff}{Select}{44,45,46,47,48}{Menu}
  72. {{44}<Horizontal>/wwh
  73. {{45}<Vertical>/wwv
  74. {{46}<Clear>/wwc
  75. {{47}<Switch>{Pass}{F6}
  76. {{48}<Function F8>{pass}{f8}
  77.  
  78.  
  79. {{`}<Formula builder>{52}
  80. {{49}<>@{Define}{52}<>{50}{Define}
  81. {{50}<>({Define}{52}<>{51}{Define}
  82. {{51}<>){Define}{52}<>{49}{Define}
  83. {{52}<>{49}
  84.  
  85. {{F1}<Macro builder>{Menu}{1,60}{IdOff}{55,56,57}{Menu}
  86. {{55}<Define keys>
  87. {Define}{Home}{PassTxt}{Home}{PassTxt}{Define}
  88. {Define}{End}{PassTxt}{End}{PassTxt}{Define}
  89. {Define}{Up}{PassTxt}{Up}{PassTxt}{Define}
  90. {Define}{Dn}{Down}{Define}
  91. {Define}{Lft}{Left}{Define}
  92. {Define}{Rght}{Right}{Define}
  93. {Define}{PgUp}{PassTxt}{PgUp}{PassTxt}{Define}
  94. {Define}{PgDn}{PassTxt}{PgDn}{PassTxt}{Define}
  95. {Define}{Enter}~{Define}
  96. {Define}{Esc}{PassTxt}{Esc}{PassTxt}{Define}
  97. {Define}{BkSp}{Bs}{Define}
  98. {Define}{F2}{Edit}{Define}
  99. {Define}{F3}{Name}{Define}
  100. {Define}{F4}{Abs}{Define}
  101. {Define}{F5}{PassTxt}{GoTo}{PassTxt}{Define}
  102. {Define}{F6}{Window}{Define}
  103. {Define}{F7}{Query}{Define}
  104. {Define}{F8}{Table}{Define}
  105. {Define}{F9}{Calc}{Define}
  106. {Define}{F10}{Graph}{Define}
  107.  
  108. {{56}<Undefine keys>
  109. {Define}{Home}{Pass}{Home}{Define}
  110. {Define}{End}{Pass}{End}{Define}
  111. {Define}{Up}{Pass}{Up}{Define}
  112. {Define}{Dn}{Pass}{Dn}{Define}
  113. {Define}{Lft}{Pass}{Lft}{Define}
  114. {Define}{Rght}{Pass}{Rght}{Define}
  115. {Define}{PgUp}{Pass}{PgUp}{Define}
  116. {Define}{PgDn}{Pass}{PgDn}{Define}
  117. {Define}{Enter}{Pass}{Enter}{Define}
  118. {Define}{Esc}{Pass}{Esc}{Define}
  119. {Define}{BkSp}{Pass}{BkSp}{Define}
  120. {Define}{F2}{Pass}{F2}{Define}
  121. {Define}{F3}{Pass}{F3}{Define}
  122. {Define}{F4}{Pass}{F4}{Define}
  123. {Define}{F5}{Pass}{F5}{Define}
  124. {Define}{F6}{Pass}{F6}{Define}
  125. {Define}{F7}<Titles>{Menu}{1,65}{IdOff}{Select}{39,40,41,42,43}{Menu}{Define}
  126. {Define}{F8}<Windows>{Menu}{1,65}{IdOff}{Select}{44,45,46,47,48}{Menu}{Define}
  127. {Define}{F9}<Swap>{Menu}{1,65}{IdOff}{36,37,38}{Menu}{Define}
  128. {Define}{F10}<Calculation>{Menu}{1,61}{IdOff}
  129. {Select}{31,32,33,34,53,54,35}{Menu}
  130. {Define}
  131.  
  132. {{57}<Help>{pass}{F1}